Welcome Guest, you are in: • Login

devio dbscript ScrewTurn Wiki

RSS RSS

Navigation





Search the wiki
»

PoweredBy

wikibot

TableSH.PROMOTIONS
Descriptiondimension table without a PK-FK relationship with the facts table, to show outer join functionality

Columns

ColumnData TypeNullableDefaultDescription
PROMO_IDNUMBER(6, 0)not null primary key column
PROMO_NAMEVARCHAR2(30)not null promotion description
PROMO_SUBCATEGORYVARCHAR2(30)not null enables to investigate promotion hierarchies
PROMO_SUBCATEGORY_IDNUMBERnot null  
PROMO_CATEGORYVARCHAR2(30)not null promotion category
PROMO_CATEGORY_IDNUMBERnot null  
PROMO_COSTNUMBER(10, 2)not null promotion cost, to do promotion effect calculations
PROMO_BEGIN_DATEDATE(7)not null promotion begin day
PROMO_END_DATEDATE(7)not null promotion end day
PROMO_TOTALVARCHAR2(15)not null  
PROMO_TOTAL_IDNUMBERnot null  

Primary Key

Primary KeyColumns
PROMO_PKPROMO_ID

Check Constraints

Check ConstraintExpressionDescription
SYS_C005152"PROMO_ID" IS NOT NULL 
SYS_C005153"PROMO_NAME" IS NOT NULL 
SYS_C005154"PROMO_SUBCATEGORY" IS NOT NULL 
SYS_C005155"PROMO_SUBCATEGORY_ID" IS NOT NULL 
SYS_C005156"PROMO_CATEGORY" IS NOT NULL 
SYS_C005157"PROMO_CATEGORY_ID" IS NOT NULL 
SYS_C005158"PROMO_COST" IS NOT NULL 
SYS_C005159"PROMO_BEGIN_DATE" IS NOT NULL 
SYS_C005160"PROMO_END_DATE" IS NOT NULL 
SYS_C005161"PROMO_TOTAL" IS NOT NULL 
SYS_C005162"PROMO_TOTAL_ID" IS NOT NULL 

Detail Tables

Detail TableColumnReferencing Column
SH.COSTSPROMO_IDPROMO_ID
SH.SALESPROMO_IDPROMO_ID

ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam.